package com.itheima.mapper.smsMapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itheima.domain.db.sms.SmsCoupon;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;


@Mapper
public interface SmsCouponMapper extends BaseMapper<SmsCoupon> {

    @Select("select * from  sms_coupon" +
            "where name like #{name},type = #{type}  " +
            "limit #{pageStart},#{pageSize}")
    List<SmsCoupon> findByCategoryName(String name, Integer pageStatr, Integer pageSize, Integer type);

}
